EMT Practice Test

1. Question Content...

---

Question1: A sales analyst needs to report how the sales team is performing to target. Which of the following files will be important in determining 2019 performance attainment?

Question2: An analyst is reporting on the average income for a county and is reviewing the following data:

Which of the following is the reason the analyst would need to cleanse the data in this data set?

Question3: Which of the following best describes the law of large numbers?

Question4: An analyst is currently working on a ticket for revamping a company-wide dashboard that has been in use for five years. Which of the following should be the first step in the development process?

Question5: A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

Question6: A financial analyst is creating a daily billing report for a company. One night, the company's data warehouse did not update the data, which caused the data to be reported incorrectly the next day. Which of the following documentation elements should the analyst add to catch this error?

Question7: Which of the following data manipulation techniques is an example of a logical function?

Question8: A company notifies its employees that emails will be automatically moved to a cloud-based server in 180 days. Which of the following describes this concept?

Question9: Which of the following technologies would be best suited for creating a multiple linear regression model?

Question10: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question11: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question12: During data profiling, an analyst decides to recode the status column in the following data set:

Which of the following data concerns explains why the analyst wants to take this action?

Question13: A data analyst is attempting to understand how ice cream consumption is affected by different attributes. such as cost, temperature. and income level. Which of the following regression analyses should the data analyst perform to understand this relationship?

Question14: An analyst has written the following code:
SELECT *
FROM Cust_table
WHERE age > 60 AND City = "New York"
Which of the following criteria is the analyst retrieving?

Question15: A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for its region and the combined sales for all regions. Which of the following would be the most efficient method for meeting the requirements?

Question16: An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Question17: A business unit made the following modification to the values in a table:

Which of the following data quality dimensions was applied in this scenario?

Question18: Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

Question19: Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Question20: A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

Question21: A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table -
In-store Transactions -

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

Question22: An analyst is working with a data set that lists individuals' first and last names in separate columns. Which of the following processes should the analyst use to combine the first and last names into a single spreadsheet cell?

Question23: Given the table below:

Which of the following variables can be considered inconsistent, and how many distinct values should the variable have?

Question24: A gambler thinks that a coin is fair and is equally likely to turn up heads or tails when the coin is flipped. Which of the following tests should the gambler use to fest this hypothesis?

Question25: What SQL command is used to delete an entire table from a database?

Question26: A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

Question27: Which one of the following would not normally be considered a summary statistic?

Question28: A data analyst is developing a dashboard to track and monitor metrics. Which of the following best practices should be taken into during the FIRST pment process?

Question29: An analyst needs to join two tables of data together for analysis. All the names and cities in the first table should be joined with the corresponding ages in the second table, if applicable.

Which of the following is the correct join the analyst should complete. and how many total rows will be in one table?

Question30: When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.
What term describes this action?

Question31: Which of the following reports can be used when insight into operational performance is needed each Wednesday?

Question32: A report is scheduled to run and be distributed at the end of business each day. On Mondays, one of the recipients opens the previous week's reports and combines them to calculate the weekly totals and projections for the coming week. This is a tedious process, and the recipient asks an analyst for help. Which of the following should the analyst recommend?

Question33: Which of the following is the best description of the term "data governance"?

Question34: Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5.000.000 rows?

Question35: A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?

Question36: Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?

Question37: Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region namecolumns to create a full address?
full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

Question38: A data analyst needs to apply quality control concepts to a data set for accuracy. Which of the following is the best way to do this?

Question39: An analyst is building a new dashboard for a user. After an initial conversation with the user. the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock-up?

Question40: Which of the following types of analysis would be best for an analyst to use to examine the relationships between authors who cited other authors in a library of research papers?

Question41: Given the table below:

Which of the following variable types BEST describes the "Year" column?

Question42: During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?

Question43: A data analyst has been asked to organize the table below in the following ways:
By sales from high to low -
By state in alphabetic order -

Which of the following functions will allow the data analyst to organize the table in this manner?

Question44: Which of the following is most likely to be used as a data-mining ETL tool?

Question45: Given the following data:

Which of the following BEST describes the data set?

Question46: Which of the following analysis techniques is an unsupervised data mining process?

Question47: Which of the following is the correct data type for text?

Question48: Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.
In what phase are the group's R skills most relevant?

Question49: An analyst wants to extract data from a variety of sources and store the data in a cloud-based environment prior to cleaning. Which of the following integration techniques should the analyst use?

Question50: Given the following table:

Which of the following methods is the best way to describe the changes in the values in the table?

Question51: An analyst is currently working on a ticket to revamp a company-wide dashboard that has been in use for five years. Which of the following should be the first step in the development process?

Question52: An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

Question53: Which of the following roles is responsible for ensuring an organization's data quality, security, privacy, and regulatory compliance?

Question54: An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst's goal?

Question55: Which of the following is an example of a flat file?

Question56: A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?

Question57: A data set for sales per month includes the following data:

Which of the following cleaning and profiling methods should be applied to the data set?

Question58: A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

Question59: While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Question60: Which of the following data governance concepts fits into the security requirements category?

Question61: Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Question62: An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

Question63: A data analyst who works for a government agency is required to obtain the average income of citizens. The list of citizens is given in the following table:

A value for one citizen's income is missing. Which of the following approaches should the data analyst take to solve this issue?

Question64: The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

Question65: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to BEST display the data?

Question66: A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

Question67: Which of the following reports can be used when insight into operational performance is needed each Wednesday?

Question68: An analyst conducted a preliminary analysis for a data set and identified several patterns and anomalies. Which of the following analysis techniques did the analyst use?

Question69: An analyst needs to know what data an organization possesses. Which of the following is the best document for the analyst to consult?

Question70: A research analyst collects ten data points from 1.000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information by specifier. Which of the following is the best data structure for the analyst to use?

Question71: Five dogs have the following heights in millimeters:
300, 430, 170, 470, 600
Which of the following is the mean height for the five dogs?

Question72: A healthcare data analyst notices that one data set in the column for BloodPressure contains several outliers that need to be replaced with meaningful values. Which of the following data manipulation techniques should the analyst use?

Question73: Which of the following data types must be used when working with variables that require classification into two or more groups before analysis?

Question74: A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below:

Which of the following steps should the analyst take to create the table?

Question75: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question76: Five dogs have the following heights in millimeters:
300,430, 170, 470, 600
Which of the following is the standard deviation for the five dogs?

Question77: A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid.
Which of the following query optimization techniques would effectively prevent SQL Injection attacks?

Question78: An organization wants to evaluate whether project activities are within the set projections and in line to meet the desired project targets. Which of the following types of analysis is best suited for this situation?

Question79: A sales director has requested a report for individual team members within the division be developed. The director would like the report to be shared with all team members, but individual team members should not be identifiable within the report Which of the following access requirements would support the director's needs?

Question80: What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?

Question81: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question82: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question83: A data analyst is helping a retail store categorize its customers into five different groups based on the following information:
* How recently the customers made purchases
* How frequently the customers made purchases
* How much the customers spent
Given the following information:

Which of the following would be most important for the analysis?

Question84: A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered?

Question85: Given the below:

Which of the following numbers represents a Type I error?

Question86: Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Question87: Which of the following is a control measure for preventing a data breach?

Question88: 'Which of the following is the BEST reason to use database views instead of tables?

Question89: A data analyst has a set of data that shows the number of gallons of oil produced each day. The company would like to know the standard deviation for the data set. The variance for the data is 36 gallons. Which of the following is the standard deviation for gallons produced?

Question90: A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?

Question91: You are working with a professional statistician to perform an analysis and would like to use a statistics package.
Which one of the following would be the most appropriate?

Question92: A user imports a data file into the accounts payable system each day. On a regular basis. the field input is not what the system is expecting. so it results in an error for the row and a broken import process. To resolve the issue, the user opens the file, finds the error in the row, and manually corrects it before attempting the import again. The import sometimes breaks on subsequent attempts. though. Which of the following changes should be made to this process to reduce the number of errors?

Question93: An analyst collected data that includes primary account numbers, expiration dates, and service codes. Which of the following data governance classifications is used to describe this data?

Question94: Which of the following is an example of a data-mining ETL tool?

Question95: Given the data below:

In which of the following file formats is the data presented?

Question96: A company's marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought the product, at what frequency, and at what value. Which of the following types of analysis would this practice be considered?

Question97: Which of the following will MOST likely be streamed live?

Question98: Which of the following database schemas features normalized dimension tables?

Question99: Which of the following is the best technique for transferring data from one database to another with some data manipulation?

Question100: A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals' earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

Question101: Given the following tables:

Which of the following will be the dimensions from a FULL JOIN of the tables above?

Question102: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question103: Which of the following describes the use of a representative amount of data from a main repository?

Question104: Which of the following is the best reason to use database views instead of tables?

Question105: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to best display the data?

Question106: Which of the following file formats is best suited to start exploratory analysis within statistical software?

Question107: A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

Question108: A reporting analyst is creating a dashboard that shows the year-over-year performance for a sales organization. Which of the following is the best visual for the analyst use to illustrate the organization's performance?

Question109: A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Question110: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question111: Which of the following statements would be used to append two tables that have the same number of columns?

Question112: A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Given the following tables:

Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?

Question113: Given the following grocery store orders:

If a query is made to the table with the following logic:
Order_Total > 132 OR (Order Total >= 25 AND Order_Total < 74)
Which of the following is the number of orders that will be returned by the query?

Question114: Given the following data set:

Which of the following is the best reason for cleansing the data?

Question115: Which of the following is an example of structured data?

Question116: A data analyst is creating a dashboard and trying to identify the type of information that should be included. Which of the following should the analyst consider first?

Question117: Which of the following best describes a 95% confidence interval?

Question118: Given the table below:

Which of the following boxes indicates that a Type Il error has occurred?

Question119: Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?

Question120: Which one of the following is a measure of dispersion?

Question121: Angela is aggregating data from CRM system with data from an employee system.
While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system.
What kind of issues is Angela facing?
Choose the best answer.

Question122: A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered?

Question123: Which of the following is a KPI metric for tracking sales performance?

Question124: After the daily ETL jobs are completed, the data in the reports does not appear complete, and a lot of data seems to be missing. Which of the following concepts should be used to assess and investigate further?

Question125: Which of the following best describes how discrete data differs from continuous data?

Question126: Which of the following report types is most appropriate for a high-level, year-end report requested by a Chief Executive Officer?

Question127: Which of the following is a non-parametric test?

Question128: A Chief Executive Officer (CEO) is requesting more up-to-date sales data for improved visibility prior to month-end. An analyst must determine the frequency of a sales report that was previously distributed on an as-needed basis. Which of the following would be the most appropriate frequency for this report?

Question129: Given the image below:

Which of the following file formats is depicted?

Question130: A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

Question131: A data analyst was asked to create a chart that shows the relationship between study hours and exam scores for each student using the data sets in the table below:

Which of the following charts would BEST represent the relationship between the variables?

Question132: Standardized tests are given to students in the middle of each month, and the results are ready by the end of the month. The superintendent needs a quick view of test performance. Which of the following would be the best recommendation to meet the superintendent's requirements?

Question133: A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control method for the administrator to use?

Question134: Which of the following techniques is used to quantify data?

Question135: Which of the following statistical methods requires two or more categorical variables?

Question136: Which of the following activities occurs during the ETL process?

Question137: A data analyst needs to perform a full outer join of a customer's orders using the tables below:

Which of the following is the mean of the order quantity?

Question138: Consider this dataset showing the retirement age of 11 people, in whole years:
54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60
This tables show a simple frequency distribution of the retirement age data.

Question139: An analyst is designing a dashboard that will provide a story of the sales and sales customer ratio. The following data is available:

Which of the following charts should the analyst consider including in the dashboard?

Question140: A salesperson who is prospecting potential clients collected the following data:

Which of the following is an issue with this data?

Question141: A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to find the measure of dispersion?

Question142: Which of the following would a data analyst look for first if 100% participation is needed on survey results?

Question143: Which of the following is the best reason for removing data outliers?

Question144: Which of the following is a process that is used during data integration to collect, blend, and load data?

Question145: Which of the following is a best practice when updating a legacy data source?